package cn.pro.wyn.jdbc;

import java.sql.*;
import java.util.Scanner;

public class APPLogin {
    public static void main(String[] args) throws Exception {
        Scanner scanner =new Scanner(System.in);

        System.out.println("请输入账号：");
        String username = scanner.nextLine();

        System.out.println("请输入密码：");
        String password = scanner.nextLine();

        login(username,password);
    }
    public static  void login(String n,String p) throws Exception {
        System.out.println("输入的账号是："+n);
        System.out.println("输入的密码是："+p);
        String sql="SELECT id FROM `user` WHERE username = ? AND `password`= ?;";
        System.out.println("组成的SQL语句是："+sql);
        Class.forName("com.mysql.jdbc.Driver");
        Class.forName("com.mysql.jdbc.Driver");
        String url="jdbc:mysql://localhost:3306/test?useSSL=false";
        String username="root";
        String password="root";
        Connection connection = DriverManager.getConnection(url, username, password);
        PreparedStatement ps = connection.prepareStatement(sql);
        ps.setString(1,n);
        ps.setString(2,p);
        ResultSet set =ps.executeQuery();
        if(set.next()){
            System.out.println("登录成功");
        }else{
            System.out.println("登录失败");
        }
    }
}
